-- =========================================
-- Author: Jacob Gable
-- Created: 02.00.2009
-- Notes: Creation of Workout table.
-- 
-- 
-- =========================================

IF OBJECT_ID('dbo.Workout', 'U') IS NOT NULL
  DROP TABLE dbo.Workout
GO

CREATE TABLE dbo.Workout
(
	WorkoutId int identity(1,1) NOT NULL, 
	UserId uniqueidentifier	foreign key references aspnet_users(UserId)
			NOT NULL,
	CreatedDate datetime NOT NULL, 	
	ts timestamp NULL,
    CONSTRAINT PK_Workout PRIMARY KEY (WorkoutId)
)
GO
